[dbo].[vSoaGLAccount]

SQLServer > iMIS1521GA > Views > dbo.vSoaGLAccount

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:31:36 PM Friday, June 03, 2011
Last Modified	1:49:26 PM Thursday, September 22, 2011

Columns

Name
GLAccountId
FinancialEntityId
Name
GLAccountCode

SQL Script

CREATE VIEW [dbo].[vSoaGLAccount]
AS
SELECT     o.OrgCode + '-' + a.CODE AS GLAccountId, o.OrgCode AS FinancialEntityId, a.DESCRIPTION AS Name, a.CODE AS GLAccountCode
FROM         dbo.Gen_Tables AS a CROSS JOIN
                      dbo.Org_Control AS o
WHERE     (a.TABLE_NAME = 'GL_Account')

GO

Uses

[dbo].[Gen_Tables]
[dbo].[Org_Control]
dbo